/*
 Navicat Premium Data Transfer

 Source Server         : MySql-3308-5.7
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : 192.168.2.167:3308
 Source Schema         : fescar

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 09/03/2019 17:19:01
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_account
-- ----------------------------
DROP TABLE IF EXISTS `t_account`;
CREATE TABLE `t_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `amount` double(14,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='扣减用户账户\n';

-- ----------------------------
-- Records of t_account
-- ----------------------------
BEGIN;
INSERT INTO `t_account` VALUES (1, '1', 3996.00);
COMMIT;

-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(255) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `commodity_code` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT '0',
  `amount` double(14,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 COMMENT='生成订单号\n';

-- ----------------------------
-- Records of t_order
-- ----------------------------
BEGIN;
INSERT INTO `t_order` VALUES (69, '965e689bb9434869899111376760aeec', '1', 'C201901140001', 2, 1.00);
INSERT INTO `t_order` VALUES (70, '9699fbe87bd84fa7bffa904cdf7aacb3', '1', 'C201901140001', 2, 1.00);
INSERT INTO `t_order` VALUES (71, '124e7b4064ce460f833c63cbb1a95b44', '1', 'C201901140001', 2, 1.00);
INSERT INTO `t_order` VALUES (72, 'ee6a2f97e90f46e6895aea1911c43d6d', '1', 'C201901140001', 2, 1.00);
COMMIT;

-- ----------------------------
-- Table structure for t_storage
-- ----------------------------
DROP TABLE IF EXISTS `t_storage`;
CREATE TABLE `t_storage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `commodity_code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `commodity_code` (`commodity_code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='扣减库存\n';

-- ----------------------------
-- Records of t_storage
-- ----------------------------
BEGIN;
INSERT INTO `t_storage` VALUES (1, 'C201901140001', '水杯', 992);
COMMIT;

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) NOT NULL,
  `xid` varchar(100) NOT NULL,
  `rollback_info` longblob NOT NULL,
  `log_status` int(11) NOT NULL,
  `log_created` datetime NOT NULL,
  `log_modified` datetime NOT NULL,
  `ext` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_unionkey` (`xid`,`branch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8 COMMENT='全局事务异常';

-- ----------------------------
-- Records of undo_log
-- ----------------------------
BEGIN;
INSERT INTO `undo_log` VALUES (120, 2005777860, '192.168.2.167:8091:2005777859', 0x7B226272616E63684964223A323030353737373836302C2273716C556E646F4C6F6773223A5B7B226166746572496D616765223A7B22726F7773223A5B7B226669656C6473223A5B7B226B657954797065223A225072696D6172794B6579222C226E616D65223A226964222C2274797065223A342C2276616C7565223A317D2C7B226B657954797065223A224E554C4C222C226E616D65223A22636F756E74222C2274797065223A342C2276616C7565223A3939387D5D7D5D2C227461626C654E616D65223A22745F73746F72616765227D2C226265666F7265496D616765223A7B22726F7773223A5B7B226669656C6473223A5B7B226B657954797065223A225072696D6172794B6579222C226E616D65223A226964222C2274797065223A342C2276616C7565223A317D2C7B226B657954797065223A224E554C4C222C226E616D65223A22636F756E74222C2274797065223A342C2276616C7565223A313030307D5D7D5D2C227461626C654E616D65223A22745F73746F72616765227D2C2273716C54797065223A22555044415445222C227461626C654E616D65223A22745F73746F72616765227D5D2C22786964223A223139322E3136382E322E3136373A383039313A32303035373737383539227D, 0, '2019-03-08 13:50:12', '2019-03-08 13:50:12', NULL);
INSERT INTO `undo_log` VALUES (121, 2005849030, '192.168.2.167:8091:2005849029', 0x7B226272616E63684964223A323030353834393033302C2273716C556E646F4C6F6773223A5B7B226166746572496D616765223A7B22726F7773223A5B7B226669656C6473223A5B7B226B657954797065223A225072696D6172794B6579222C226E616D65223A226964222C2274797065223A342C2276616C7565223A317D2C7B226B657954797065223A224E554C4C222C226E616D65223A22636F756E74222C2274797065223A342C2276616C7565223A3939367D5D7D5D2C227461626C654E616D65223A22745F73746F72616765227D2C226265666F7265496D616765223A7B22726F7773223A5B7B226669656C6473223A5B7B226B657954797065223A225072696D6172794B6579222C226E616D65223A226964222C2274797065223A342C2276616C7565223A317D2C7B226B657954797065223A224E554C4C222C226E616D65223A22636F756E74222C2274797065223A342C2276616C7565223A3939387D5D7D5D2C227461626C654E616D65223A22745F73746F72616765227D2C2273716C54797065223A22555044415445222C227461626C654E616D65223A22745F73746F72616765227D5D2C22786964223A223139322E3136382E322E3136373A383039313A32303035383439303239227D, 0, '2019-03-09 08:51:56', '2019-03-09 08:51:56', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
